DROP-ENCRYPT-KEY
DROP-ENCRYPT-KEY
Name
DROP ENCRYPTKEY
Description
Syntax:
DROP ENCRYPTKEY key_name
Parameter Description:
key_name: the name of the key to be deleted. It can include the name of the database, for example,db1.my_key.
If you are to delete a custom key, please make sure the key name is exactly correct.
Executing this command requires the user to have ADMIN privileges.
Example
Delete a key
DROP ENCRYPTKEY my_key;
Keywords
DROP, ENCRYPT, KEY
